cd c:
cd \SSASMonitoringScriptsForManagementDataWarehouse
SET MDWServer=MDWServer
SET SSASServer=SSASServer
SET SSASServerInstance=SSASServer
SET ReadSSASCoreJobSchedule=60
SET PerfCounterPrefix=MSAS 2008
REM SET PerfCounterPrefix=MSOLAP$INSTANCENAME


sqlcmd -S %SSASServer% -i Stop_System_Collection_Sets.sql 
sqlcmd -S %MDWDataCollectionServer% -i Purge_Core_MDW.sql
sqlcmd -S %SSASServer% -i SSAS_Monitoring_Core.sql
pause
